Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Save As problem

I have a workbook that has some code behind in a few sheets. When a user
chooses to save the file as "Save As" to name it different, one of the
dropdown box's change code runs. This is causing an issue because this code
changes some other values that shouldn't change when you are trying to save.
I don't know why it is running this code.Thanks in advance for any help.
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35,218
Default Save As problem

Do you have a .linkedcell for that combobox on that same sheet? How about the
..listfillrange?

Moving them to a different sheet may help--or doing the equivalent in code would
help.

cshelton17 wrote:

I have a workbook that has some code behind in a few sheets. When a user
chooses to save the file as "Save As" to name it different, one of the
dropdown box's change code runs. This is causing an issue because this code
changes some other values that shouldn't change when you are trying to save.
I don't know why it is running this code.Thanks in advance for any help.


--

Dave Peterson
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
Problem with Save As Nihal Chand Excel Discussion (Misc queries) 2 July 7th 08 02:29 PM
"Save" macro problem, still prompted to save when closing workbook (?) StargateFanFromWork[_4_] Excel Programming 8 September 13th 06 04:49 PM
Problem with 'save as' Boz Excel Discussion (Misc queries) 1 April 7th 06 08:35 PM
Save as problem with Save In drop down box Doug Excel Discussion (Misc queries) 3 March 16th 06 02:46 PM
save problem Anthony Excel Discussion (Misc queries) 3 March 14th 05 06:37 PM


All times are GMT +1. The time now is 09:00 PM.

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"