ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Macro Run-time error (https://www.excelbanter.com/excel-discussion-misc-queries/86500-macro-run-time-error.html)

shirley_kee

Macro Run-time error
 

I have created a user form for data entry. When my users open the excel
file which contains macro, 2 errors will occur

1. *"Run-time error '1004': Document not saved.* (This error is under
Microsoft Visual basic)

*2. An unexpected error has occured. AutoRecover has been disabled for
this session of Excel.* (This error is under Excel)

U r g e n t ! ! !


--
shirley_kee
------------------------------------------------------------------------
shirley_kee's Profile: http://www.excelforum.com/member.php...o&userid=30384
View this thread: http://www.excelforum.com/showthread...hreadid=538352


Chip Pearson

Macro Run-time error
 
Post the code that is causing the error and indicate which line
of code causes the error.


"shirley_kee"
wrote
in message
...

I have created a user form for data entry. When my users open
the excel
file which contains macro, 2 errors will occur

1. *"Run-time error '1004': Document not saved.* (This error is
under
Microsoft Visual basic)

*2. An unexpected error has occured. AutoRecover has been
disabled for
this session of Excel.* (This error is under Excel)

U r g e n t ! ! !


--
shirley_kee
------------------------------------------------------------------------
shirley_kee's Profile:
http://www.excelforum.com/member.php...o&userid=30384
View this thread:
http://www.excelforum.com/showthread...hreadid=538352





All times are GMT +1. The time now is 07:13 PM.

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