Once-only Macro

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi

I have a template .xlt with code in (or a macro called from) the workbook
open event to format various cells.
The template is then saved as a .xls
How can I removed the workbook open event code when the .xlt is saved as .xls

Thanks
Libby
.

Relevant Pages

  • Re: Save lookup data in template (.xlt)
    ... When you store the code/data in a .xlt, then every workbook that's based on this ... knows how many workbooks could have created using the .xlt template workbook. ...
    (microsoft.public.excel.programming)
  • Re: New from Template Issue
    ... If you open the .xlt (template workbook) to edit, ... If you want to fix that "problem", you can reregister excel. ...
    (microsoft.public.excel.programming)
  • Re: XLT files will not save as XLS
    ... How about using File|New to create the new workbook instead. ... double clicking on a .xlt file. ... If you rightclick on a .xlt file in windows explorer, you'll see New and Open, ... If I open a template from a network drive by starting Excel and using ...
    (microsoft.public.excel.misc)
  • Re: How to start template with connected workbook
    ... a workbook created from a template has no path until ... open the wb2). ... Of course if the open event found the workbook had a path, ...
    (microsoft.public.excel.programming)
  • Re: Remove/disable event macros in SavedAs wkbk?
    ... Just like clicking on the New Icon on the standard toolbar creates a workbook ... template to edit it--not as a basis for a new workbook. ... File|New then pointing to that template file or double clicking on the *.xlt ... >> Dave Peterson ...
    (microsoft.public.excel.programming)