How to reduce the number of 'clicks' when saving

  • Thread starter Thread starter Miket99
  • Start date Start date
M

Miket99

How can I control the number of clicks to one when saving changes in an
Excel spread sheet? I use lots of small sheets which I edit and save
and every time I click the save button I get three or more "are you
sure" questions all of which I want to answer yes.

Finger fatigue!!
 
If you save a workbook over an existing workbook using a tool button, you'll
always get an "are you sure" warning. The only way to save a previously
saved workbook over itself without a warning is to use Ctrl-s or File, Save.
 
Crtl + S = File Save (also Alt + F, S)
Alt + F, A = Save as


:
: How can I control the number of clicks to one when saving changes in an
: Excel spread sheet? I use lots of small sheets which I edit and save
: and every time I click the save button I get three or more "are you
: sure" questions all of which I want to answer yes.
:
: Finger fatigue!!
:
:
: ------------------------------------------------
:
:
:
: ~~Now Available: Financial Statements.xls, a step by step guide to creating
financial statements
 
Jim said:
*If you save a workbook over an existing workbook using a tool
button, you'll
always get an "are you sure" warning. The only way to save a
previously
saved workbook over itself without a warning is to use Ctrl-s or
File, Save.

Jim, Thank you for responding. When clicking "Clt S" or the "X" to
close the workbook, I still get three confirm messages. No way around
this huh?

Mike Thomas
 
Are you saving as a normal excel file or some other format?

You may want to post the text of the prompts to get more help, too.
 

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

Back
Top