Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable functions on command bar
For data protection, I want to disable the ability to SAVE, PRINT, EMAIL,
COPY & PASTE within a given spreadsheet with only one sheet of data. I need this to run as soon as the spreadsheet is opened and obviously reset itself once the spreadsheet is closed so that it does not affect other spreadsheets. I have good Excel knowledge, but an a relative beginner when it comes to macros. Any help would be much appreciated. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable functions on command bar
Hi,
Ron De Bruin has all the methods here http://www.rondebruin.nl/menuid.htm -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "starbug1999" wrote: For data protection, I want to disable the ability to SAVE, PRINT, EMAIL, COPY & PASTE within a given spreadsheet with only one sheet of data. I need this to run as soon as the spreadsheet is opened and obviously reset itself once the spreadsheet is closed so that it does not affect other spreadsheets. I have good Excel knowledge, but an a relative beginner when it comes to macros. Any help would be much appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Disable Command Bar Control | Excel Programming | |||
Disable Command Button | Excel Programming | |||
How disable menu command | Excel Discussion (Misc queries) | |||
Disable command button | Excel Programming | |||
Disable a command from with in a workbook | Excel Programming |