Through code : Making a global change to 100 templates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a few hundred templates. each template has some forms and oee of the
forms pops up on worksheet open.

Now the challenge is that i have a global change to make to all the
templates : making the sheet tabs available (which are originally hidden).

I want to do it through code rather than going to each of the template and
doing it manually...

Any ideas....thoughts would be highly appreciated.
 
How about using SendKeys to cancel the form ?
(presumably this is all you wanted).
or
code to unload the form
 
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

Excel Template Question... 2
Date formats change (code included) 9
Changing Global Template Default of Footnotes 0
Excel loses mind clearing VBA global variables 2
Automatically Adding a Worksheet 14
How to populate a template for each customer 1
copying a template sheet and inputting a formula into another sheetthat references the new sheet 1
Macro to Copy hidden worksheet to new worksheet 4

Back
Top