View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default 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