Macro Dialog Box Help

  • Thread starter Thread starter Duppypog
  • Start date Start date
D

Duppypog

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
 
The code is protected in the VBA editor

Alt-F11
In the menubar Tools>VBA project properties
See the protection tab

Ask for the password
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to Unlock Excel Workbook protected by MACRO Password 6
Macro to launch the Activate dialog box? 2
Problem in adding macro to ribbon through Add-in 7
How to apply a macro to all workbooks 2
Macro warning with no macros 4
Macros missing 3
macro free workbook saves macro 0
Macro to copy a sheet and delete a macro button 8

Back
Top