| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem: vba code for creating a button to save worksheet as Cell
Public Sub SaveAsA1() ThisFile = Range("A1").Value ActiveWorkbook.SaveAs Filename:=ThisFile End Sub I have created a button that would save the worksheet as the value in cell A1. I keep getting an error with the above code. Can someone point out where I am going wrong , and suggest an alternative way of coding for this cmd. Thanks, Steve |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| creating a button to activate another worksheet within a workbook | Excel Programming | |||
| Creating a Command Button on a worksheet | Excel Discussion (Misc queries) | |||
| Creating some sort of button that will take you to a new worksheet | New Users to Excel | |||
| Great Code : Need Modification - VBA Save Button | Excel Programming | |||
| save button in excel to save one of the worksheets with a cell value as its name | Excel Programming | |||
Threaded Mode
