Can Macro update "ThisWorkbook" sheet?

  • Thread starter Thread starter Don
  • Start date Start date
D

Don

Under Microsoft Excel Objects is a sheet called ThisWorkbook. It has some
code that will not work under Office 2007 and I need to update over 500
spreadsheets. Is there an automated way to update this by a macro I have
open or do I have to open every workbook , open the VB menue and update?

Never updated the code automaticly
 

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

2007 View Code ThisWorkbook 2
Macro to email spreadsheet 2
Help to create a macro 2
Programatically adding macro to Excel - "ThisWorkbook" 3
Macro to Remove Macro Text 1
Workbook with macro unvisable in VBE 3
ActiveWorkBook versus ActiveSheet 5
Excel Providing user message when RED X clicked & properly closing application. 2

Back
Top