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
tesla764Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Patrick MatthewsCommented:
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
0
tesla764Author Commented:
How would I do that?
0
[ fanpages ]IT Services ConsultantCommented:
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.
0
Newly released Acronis True Image 2019

In announcing the release of the 15th Anniversary Edition of Acronis True Image 2019, the company revealed that its artificial intelligence-based anti-ransomware technology – stopped more than 200,000 ransomware attacks on 150,000 customers last year.

tesla764Author Commented:
Yes to all questions.
0
[ fanpages ]IT Services ConsultantCommented:
:)

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!
0
tesla764Author Commented:
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.
0
tesla764Author Commented:
Actually the file should be saved in the directory where the program is running from.
0
tesla764Author Commented:
I got this one figured out.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
[ fanpages ]IT Services ConsultantCommented:
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! :)
0
[ fanpages ]IT Services ConsultantCommented:
Sorry,... no, I have no objections to this question being closed.
0
tesla764Author Commented:
While waiting I managed to figure this out.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Applications

From novice to tech pro — start learning today.