Save worksheet

  • Thread starter Thread starter Hugh
  • Start date Start date
H

Hugh

Hi there,

My excel application has a single worksheet on a workbook
with columns of data and a chart. A couple of forms will
pop up if the workbook is open. Now, I want to save
worksheet (or workbook) without saving the code. How do I
do it? I used SAVEAS function. However, the code was also
saved, and the forms pop up when saved file is open. How
do I make sure only data and chart are saved? Thanks in
advance.

Hugh
 
I answered your post in the programming newsgroup. Please don't post the same
question to multiple groups. If someone else had answered this post, one or
the other of us would have wasted our time on a 2nd answer.
 
Hi Myrna,

I was new to group and no sure if the question would be
picked up by readers. I thought that some people might
read only certain topics. I have replied your answer in
programming group. Thanks fro help.

Hugh
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

(DAVE PETERSON) - SAVE WORKSHEET AS A NEW WORKBOOK 6
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
When you hit Save on a template, how can you save as worksheet? 1
Save Workbook or worksheet 3
Worksheet compatability 1
Saving & Removing VB Code from WB 6
Time required to 'save as' a large file 4
Is a combination of INDIRECT with INDIRECT.EXT, a component ofmorefunc.xll by Laurent Longre, valid? 1

Back
Top