I routinely use macros (recorded and then edited in the VB Editor and often assigned to buttons) but I have noticed that when I create them in a file that is saved as a webpage (HTM file extension) I lose the macros when I reopen the file.
I'm opening all files using Frontpage 2002, in case that makes a difference.
Is there a workaround for this?
As background: I like to save the files as HTM since most of the worksheets are being viewed by others either via our Intranet or via the Internet. And they can read them with their browser (as opposed to the XLS file type that will cause Excel to open unnecessarily).
I have no trouble working with macros in other files (saved as XLS). It seems to be a problem related to the file type.