Buttons in sheet

[paulglad]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Hi there,

I know there is no VBA in Excel 2008 - But I just want to add a 'paste values' button into the sheet I am creating - so other users can click it without knowing about it. Is there any way to, say, hyperlink to the inbuilt command? I am open to any suggestions that will work across excel version on multiple operating systems. Explaining to go to edit > paste special > etc will just cause problems and frustration to a non tech savvy audience.

Many thanks,
Paul

 

[CyberTaz]

You can't put it "on the sheet" but you can add it to any Toolbar.

Go to View> Customize menus & Toolbars - Commands, select Edit in the
Categories list, then locate Paste Values in the Commands list & drag it
into position on the toolbar of choice.

HTH |:>)
Bob Jones
[MVP] Office:Mac

 

[paulglad]

Thanks Bob - will look into it - I have found something else which may be of interest to you/other users..

My issue is that when the user hits the normal paste button/via edit menue/right click/cmd+V etc. the conditional formatting etc. is over written. Hence the need for paste values.

I have found that this is not the case when pasting into a merged cell (i.e. 2 cells merged to 1)

if the paste destination is a merged cell then the user can use any of the above paste options and the conditional formatting is preserved!

If this works across platform/versions, then this is a really neat way to create relatively fool proof user input cells - I have only tested this in excel 2008 for mac - and would value anyone else's input.

Paul

 

[CyberTaz]

I don't mean to rain on your parade, but the cure you've discovered is worse
than the disease To quote the eminent J.E. McGimpsey, "Merged cells are
Satan's spawn!" They will cause an extensive array of problems & corrupt a
workbook file as fast as any other contrivance you can impose.

In all honesty I believe you'd do better to train the users to simply paste,
then have them use the Paste Options button to select "Values & Source
Formatting". Unfortunately, without VBA there is no single button solution
unless something can be created using Apple Script.

Other options include replacing the Paste button with the Paste Special
button or just adding Paste Special to the toolbar, but that won't help if
anyone uses Command+V or refuses to comply with your request. In my
experience, though, it's virtually impossible to force users to do what you
want without preventing them from having any other options... And those
options are usually needed for other purposes.

There is no substitute for proper training, and [please don't be offended]
neither of these operations (especially use of the Paste Options button)
require any degree of "tech savvy" whatsoever... It's a simple matter of
compliance. It may sound rather hard-core, but perhaps those who refuse or
are unable to comply with the requirements shouldn't be doing the job

Regards |:>)
Bob Jones
[MVP] Office:Mac

 

[paulglad]

Cheers Bob - I certainly don't feel rained on rather just caught between a rock and a hard place. That's what happens when neither the human of the machine work properly
Paul

 

[CyberTaz]

How well I understand But seriously, you might want to look into the
Apple Script approach. I'm afraid I can't help with that, though.

Another thought that crossed my mind: even though Office 2008 doesn't
support VBA, Excel still supports Excel 4.0 Macro Language. It's been nearly
100 years since I've dealt with it & so much has changed since then that I
honestly don't remember if it can call menu commands or not... And if it can
what the capabilities/limitations might be.

Perhaps one of the others around here may have some input, so check back
periodically for other replies.

Regards |:>)
Bob Jones
[MVP] Office:Mac