Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default i want to assign a cell to save a worksheet

Looking to assign a cell to SAVE a worksheet. Need to have the word SAVE
displayed in the cell and do the SAVE AS when clicked on. This way I can name
the file as I wish. i.e. CTL,F,A

Any help would be appreciated

thx
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,942
Default i want to assign a cell to save a worksheet

hi,
see your other post.
regards
FSt1

"John Petranek" wrote:

Looking to assign a cell to SAVE a worksheet. Need to have the word SAVE
displayed in the cell and do the SAVE AS when clicked on. This way I can name
the file as I wish. i.e. CTL,F,A

Any help would be appreciated

thx

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 857
Default i want to assign a cell to save a worksheet

Hi,

Ctrl F, A is the long way to do this, you can use F12 instead for Save As.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"John Petranek" wrote:

Looking to assign a cell to SAVE a worksheet. Need to have the word SAVE
displayed in the cell and do the SAVE AS when clicked on. This way I can name
the file as I wish. i.e. CTL,F,A

Any help would be appreciated

thx

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I assign a macro to a graphic object on the worksheet bigjim Excel Discussion (Misc queries) 1 March 24th 08 03:08 AM
How to save the cell formula memory on worksheet? Eric Excel Discussion (Misc queries) 0 October 12th 07 10:13 AM
assign the same macro to every line in worksheet Hannah Excel Worksheet Functions 1 May 22nd 07 10:11 AM
macro save a file name from a cell in 1st worksheet karene Excel Discussion (Misc queries) 2 April 10th 06 12:13 PM
assign cell selection order in protected Excel worksheet tom92 Excel Discussion (Misc queries) 1 April 4th 05 05:57 PM


All times are GMT +1. The time now is 04:45 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"