make excel close sheet and follow hyperlink

[faireedoll]

firstly i am sorry if this has been asked before, i have tried searching and re phrasing the question many times but can't seem to find and answer.
I am wanting to have my workbook hyperlink to another, to stop ending up with multiple workbooks open, i tried to add a macro to the hyperlink to close ...being very new to excel programming features i think the macro i created is far to basic...e.g close this workbook. Can someone please help shed some light on how detailed i need to be, in the macro design in order to get this to work..

thanking you in advance
Moni

[aaronbrett]

Can you be more specific about what it is you are trying to do?

Aaron

[faireedoll]

Hi Aaron,

Thanks for the reply, i have created a workbook that is linked to other workbooks via a hyperlink, unfortuatley when i follow the hyperlinks i am left with many open workbooks, i was of the understanding that i would have to create a macro that would close the workbook i am leaving and still follow the hyperlink...this may not be the case....if this is done in a different way then i havent found out the solution, so any input is greatly appreicated.

thanks Moni

[Tom Schreiner]

Hi Moni.

I think the only way you could get the kind of behavior you are looking for, aside from placing code in every applicable workbook, would be to create an addin. Open a new workbook, place this code in the workbook class, save it as an addin (xla), load your new addin.

Note this constant:
Private Const AutoSaveChanges As Boolean = True

Assigning 'True' will automatically save each workbook without prompt. If you require the option to save changes or not, change the True assignment to False. False would allow the savechanges GUI to popup.

Please Login or Register  to view this content.