deleting worksheet code in generated workbooks

  • Thread starter Thread starter Winshent
  • Start date Start date
W

Winshent

I have a 'Return Spreadsheet' which contains modules for validation
which get triggered by worksheet events.

I have included a button for the user which generates a values only
copied version of the spread, sends it via e and then kills the
generated spread.

the only problem is the generated spread contains code related to each
sheet, but does not contain the modules which are referenced by this
code.

is it possible to either delete the worksheet code in the generated
spread?
 
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

Code execution is correct but generates Error :The file you aretrying to open is in a different form 3
Copying worksheet into another worksheet 2
Prevent user from Inserting new worksheet 4
How does Excel Know Where a Referenced Add-In Wbk is Located 1
Make function available to all workbooks? 1
Protecting worksheet cause vba code to fail 7
preventing comboboxes from triggering when sheet copied 1
Summing Generated Worksheets 7

Back
Top