| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do you hide macro names from showing in "Tools"?
I've written an application and I've protected both the worksheets an the VBA code. But the macros still show in Tools, Macros, Macros... A user can still select and run a macro from the Tools menu. I want t control all macros from the buttons I have on the various sheets of th workbook. Can I hide the macro names and/or prevent "Run" from bein chosen? Thanks in advance. Nashu -- Nashu ----------------------------------------------------------------------- Nashua's Profile: http://www.highdots.com/forums/m142 View this thread: http://www.highdots.com/forums/t307899 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do you hide macro names from showing in "Tools"?
Nashua,
Try putting this at the beginning of the module: Option Private Module Regards Pete "Nashua" wrote: I've written an application and I've protected both the worksheets and the VBA code. But the macros still show in Tools, Macros, Macros... A user can still select and run a macro from the Tools menu. I want to control all macros from the buttons I have on the various sheets of the workbook. Can I hide the macro names and/or prevent "Run" from being chosen? Thanks in advance. Nashua -- Nashua ------------------------------------------------------------------------ Nashua's Profile: http://www.highdots.com/forums/m1420 View this thread: http://www.highdots.com/forums/t3078996 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Range Names Showing Like "Watermarks" | Excel Discussion (Misc queries) | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| Macro to concatenate into "B1" B2 thru B"x" based on new data in "Col A" | Excel Discussion (Misc queries) | |||
| CommandBars("Worksheet Menu Bar").Controls("Tools").Enabled = Fals | Excel Programming | |||
| Backup to specific folder if workbook names begins with "NSR" or "MAC" | Excel Programming | |||
Linear Mode
