ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Works but... (https://www.excelbanter.com/excel-programming/310174-works-but.html)

halem2[_23_]

Works but...
 
Here it is:

I have a workbook with some vba macros. None of the macros refer t
any workbook, just to the active sheet. Every time I one the workboo
and save it, it seems to remember the first Save As file name and fro
there on, every time I open the original workbook, it also opens th
first saved as file.

How can I make it self-contained? Meaning open the original workboo
work on it, save it as something else and then when I open th
original, it won't also open the first one I saved?

Weird...

--
Message posted from http://www.ExcelForum.com


halem2[_24_]

Works but...
 
I also tried it as an add-in but since I'm replacing the toolbars an
menu, when it opens, it open opens mine plus the defaults

--
Message posted from http://www.ExcelForum.com



All times are GMT +1. The time now is 05:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com