Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Assigning a button to SAVE a sheet

Trying to assign a cell name as SAVE and have it save the sheet I am working
on to a folder when I click on it. Is this possible?

Thx
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,942
Default Assigning a button to SAVE a sheet

hi
confused. do you want to save the sheet to another file with name in a cell??
or do you just want to save a range on the sheets? is the folder a fixed
file path?
button? do you mean a command button on the sheet or icon on the toolbar?

regards
FSt1

"John Petranek" wrote:

Trying to assign a cell name as SAVE and have it save the sheet I am working
on to a folder when I click on it. Is this possible?

Thx

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,942
Default Assigning a button to SAVE a sheet

hi
after reading your other post, i think this may be what your are after.

ActiveSheet.Copy
'Workbooks.Add
'Range("A1").PasteSpecial xlPasteAll
Application.Dialogs(xlDialogSaveAs).Show


you wont be able to type the word save in a cell to launch the macro. you
can put a label from the control toolbox on the sheet, size it to the same
size as the cell, then type the word save in the label. the right click the
label and click view code.
this should default in......
Private sub label1_chick()

end sub
paste the above code between sub and end sub.

Regards
FSt1

"FSt1" wrote:

hi
confused. do you want to save the sheet to another file with name in a cell??
or do you just want to save a range on the sheets? is the folder a fixed
file path?
button? do you mean a command button on the sheet or icon on the toolbar?

regards
FSt1

"John Petranek" wrote:

Trying to assign a cell name as SAVE and have it save the sheet I am working
on to a folder when I click on it. Is this possible?

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
excel button to save sheet contents to new workbook Don Excel Programming 5 March 3rd 09 02:46 PM
Adding button in sheet & assigning it to a macro Brian Excel Programming 3 August 25th 08 05:34 PM
save only active sheet Button. tim Excel Discussion (Misc queries) 7 May 23rd 08 11:27 PM
Need help, Seq numbers, Save filename & A button on sheet. Harv Excel Discussion (Misc queries) 1 May 14th 06 11:00 PM
Assigning name to button Grant Reid Excel Programming 4 June 3rd 04 08:55 AM


All times are GMT +1. The time now is 10:53 PM.

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

About Us

"It's about Microsoft Excel"