Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Dialog Box Help
We have a workbook created by someone else that includes several macros.
The dept. wants to remove all the values and save the workbook with a new name to begin tracking a new year. When they open the newly created file, it populates cells with data from the old file. I suspect it's something in the macros causing this, but when I open the macros dialog box, edit, all the buttons except "Run" are grayed out. The workbook/worksheets aren't protected, so I'm stumped. Does anyone have any ideas what could be causing this? thanks, Lynnette |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Dialog Box Help
The code is protected in the VBA editor
Alt-F11 In the menubar ToolsVBA project properties See the protection tab Ask for the password -- Regards Ron de Bruin (Win XP Pro SP-1 XL2000-2003) www.rondebruin.nl "Duppypog" wrote in message ... We have a workbook created by someone else that includes several macros. The dept. wants to remove all the values and save the workbook with a new name to begin tracking a new year. When they open the newly created file, it populates cells with data from the old file. I suspect it's something in the macros causing this, but when I open the macros dialog box, edit, all the buttons except "Run" are grayed out. The workbook/worksheets aren't protected, so I'm stumped. Does anyone have any ideas what could be causing this? thanks, Lynnette |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro Dialog Box | Excel Discussion (Misc queries) | |||
Assign Macro Dialog Box | Excel Discussion (Misc queries) | |||
Macro dialog box won't leave me alone! | Excel Discussion (Misc queries) | |||
Dialog Box With Macro Buttons (VBA) | Excel Discussion (Misc queries) | |||
Having a macro interact with a dialog box. | Excel Programming |