Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
save and closing when hyperlink accessed
Hi all, I have a master spreadsheet that creates formated .xls sheets from a hidden and read-only .xls master template by opening the template, save as, and closeing the file. On the mastersheet, a hyperlink is created to the newly created page. I want to add a save and close action when the hyperlink is clicked on, such that the master sheet is saved and closed, and the linked xls file is opened. Haven't had much luck in doing this yet however. Tried a variety of methods, none of which have worked for me. Anyone know of a way to make this work? -- Ouka ------------------------------------------------------------------------ Ouka's Profile: http://www.excelforum.com/member.php...o&userid=23988 View this thread: http://www.excelforum.com/showthread...hreadid=498848 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
save and closing when hyperlink accessed
anyone? This is driving me bonkers! Or, is there way to pass the value of a variable between workbooks? I think I could come up with a round-about means of acheiving what I want to happen. (basically thinking of doing a on workbook activate, change the active workbook back to the master, save and close it. But that would require a variable to be passed first elsewise the user will experience an error if they open the hyperlinked file directly from windows) -- Ouka ------------------------------------------------------------------------ Ouka's Profile: http://www.excelforum.com/member.php...o&userid=23988 View this thread: http://www.excelforum.com/showthread...hreadid=498848 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why do certain worksheets ALWAYS ask if I want to save them when closing them? | Excel Discussion (Misc queries) | |||
Closing but doesn't ask to save | Excel Discussion (Misc queries) | |||
Save files before closing | Excel Discussion (Misc queries) | |||
Closing the save changes box | Excel Programming | |||
Closing the save changes box | Excel Programming |