asked on

Excel VBA work sheets

Please see the attached word document for screen shot and details.
Question...
Would there be a way, if the cursor is placed over the “DRA Summary” tab to have a message box pop up and ask if you want to save the sheet as “DRA Summay.xlsx” ? If Yes, the save that sheet as “DRA Summary.xslx”. I wouldlike to have the same functionality for the other tabs as well.
EE-Tab-Save.docx

Patrick Matthews

tesla764,

No, there is not. There is no event related to hovering over a worksheet tab.

What you could do is trap the event for activating a worksheet, and prompt the user to save that just-activated worksheet as a new file.

Patrick

tesla764

ASKER

How would I do that?

[ fanpages ]

Hi,

Will the individual worksheets (in their own workbook) be saved in the same folder where the original workbook resides?

That is, if you have ten worksheets in the main workbook, & you save the ten worksheets, the folder will then have the main workbook containing all ten worksheets, as well as ten other workbook files each with a single worksheet within them.

Thanks for your clarification.

Also, if a file with the matching filename already exists, should it be overwritten automatically, or should there be an additional prompt to warn that a file exists already?

BFN,

fp.

tesla764

ASKER

Yes to all questions.

[ fanpages ]

:)

In that case, I think I should have split this question into two:

Also, if a file with the matching filename already exists, should it be overwritten automatically, or should there be an additional prompt to warn that a file exists already?

If your reply is 'Yes' to both parts, then implementation may prove difficult!

tesla764

ASKER

In most cases there will be only one worksheet created with each run.
Actually the file should be saved in "c:\temp" directory.

As far as the file already existing. Doesn't the system prompt before over ridding anyway?

Thanks.

tesla764

ASKER

Actually the file should be saved in the directory where the program is running from.

ASKER CERTIFIED SOLUTION

tesla764

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

[ fanpages ]

OK, thanks for letting me know.

I had actually thought I would get to your question again yesterday, & even sent a hyperlink to this thread to an e-mail address I was using yesterday so I could quickly look at it before starting to write something for you but, unfortunately, I did not get the opportunity.

Glad you managed to resolve this yourself though! :)

[ fanpages ]

Sorry,... no, I have no objections to this question being closed.

tesla764

ASKER

While waiting I managed to figure this out.