Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
SaveCopyAs - Userform disappears
Hello, When the sub(i guess macro) does a SaveCopyAs all Userforms reference by the macro upto that point get messed up in ThisWorkbook. When I click at the userform in VBA project for THisworkbook it gives a path/file access error. Also, when I save THisworkbook i get a VB6 error from Excel and then Excel shuts down. For example, Sub example() Load Userform1 Unload Userform1 Thisworkbook.savecopyas filename:=("C:\temp\temp.xls") End Sub After I run example in Thisworkbook, the problems stated above occur with Userform1 and with saving changes in Thisworkbook. I will appreciate any help with this. Also, Tom thanks for your help on my previous question and thanks all in advance. ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Chart Disappears | Charts and Charting in Excel | |||
Savecopyas without password | Excel Discussion (Misc queries) | |||
Data disappears!! | Excel Discussion (Misc queries) | |||
Figure disappears after using F2 | Excel Discussion (Misc queries) | |||
SaveCopyAs with a twist | Excel Discussion (Misc queries) |