Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,814
Default disappearing macros

Howdee all.
A topic which has once again been brought to the forefront of my world....

While I've taken some of the code that's available to save my xlam, xlsb,
and other files, so that my macros don't get lost, it still occurs, and it's
getting old.

For some reason, I'll get done writing a macro, click save, or ctrl+s, and
close my file.

I'll then go into the xml side of the file, and enter my xml code to create
my menu item, gallery, etc... validate it, then generate callbacks, and save
that file, and go back my xlam, etc....

I then attempt to activate my menu access to the macro, and I get the ever
famous-- cannot run "..." macro because it's either not available, or does
not exist, or macros have been disabled.... message.

I'll then go look in the file, and behold... my macro is gone. I'll look
around, and sure enough, no module, no frm, nothing, kaput....

While this occurs more often with my exporting, and then importting a module
or form from one file to another (I do all my preliminary code work in the
xlsb file, and then ex-import it over to the xlam file once everything is
working a-ok), it still occurs, and has gotten extremely old....

My save code is activated with the opening of the excel program, and runs
every few minutes, and regardless if I just hold down the ctrl key, and hit
's' multiple times, this loss of files still occurs.

and yes, I have run office diagnostics (multiple times), and there are no
errors.

Does anyone have an idea on how to prevent this file loss from continuing to
occur?
I'd like to ask why it happens, but I'm sure that this question has been
asked a million times over, and still no answer exists.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Icon/Macros disappearing David Setting up and Configuration of Excel 1 December 23rd 09 08:49 PM
Disappearing act! JLGWhiz Excel Programming 7 September 9th 06 07:53 PM
Disappearing Macros JCW Excel Discussion (Misc queries) 0 June 21st 06 09:43 PM
Macros keep disappearing OzBushDude Excel Discussion (Misc queries) 1 December 21st 05 09:57 AM
Add-Ins Disappearing? Ben Excel Discussion (Misc queries) 3 July 18th 05 10:39 AM


All times are GMT +1. The time now is 11:52 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"