Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
BOOK: Excel 2003 VBA Programmer's Reference
This is the forum to discuss the Wrox book Excel 2003 VBA Programmer's Reference by Paul T. Kimmel, Stephen Bullen, John Green, Rob Bovey, Robert Rosenberg, Brian Patterson; ISBN: 9780764556609
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Excel 2003 VBA Programmer's Reference section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old November 18th, 2005, 03:35 PM
Registered User
 
Join Date: Aug 2005
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default "Save As" issue

I have a worksheet that populates cells based on user choices from combo boxes. When a user chooses to rename the workbook by using the "Save As" from the file menu, the macros tied to the drop down boxes run, and any data on the worksheet is erased. If a user just chooses to "Save" the file the macros do not run, and the worksheet is fine.

Is there a way to prevent this?





Similar Threads
Thread Thread Starter Forum Replies Last Post
save database kim VB How-To 3 April 2nd, 2006 09:26 AM
Save Password qazi_nomi Beginning PHP 3 August 16th, 2005 05:14 PM
How do you save a form as is? flyingfox VB.NET 1 May 21st, 2004 03:47 PM
Will not save luckychap Access 3 January 26th, 2004 01:21 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.