Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problems with active cell after saveas
My macro saves and workbook to a temp location before data entry starts.
I want E8 to be the active cell after the save. I'm using the SaveAs method followed by "Range("E8").Select". Cell E8 looks selected on the sheet but the pull down menu key strokes are active. For example, if I enter a "t" I get the Tools pull down menu, an "f" gets me the File menu, etc. I have to actually click on E8 to deactivate the pull down menus. What am I doing wrong? BrianG *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problems with active cell after saveas
Brian
It helps if you paste the code along with the query. Peter -----Original Message----- My macro saves and workbook to a temp location before data entry starts. I want E8 to be the active cell after the save. I'm using the SaveAs method followed by "Range("E8").Select". Cell E8 looks selected on the sheet but the pull down menu key strokes are active. For example, if I enter a "t" I get the Tools pull down menu, an "f" gets me the File menu, etc. I have to actually click on E8 to deactivate the pull down menus. What am I doing wrong? BrianG *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Row select mode to highlight active row of active cell | Excel Discussion (Misc queries) | |||
howto: saveas with file name from a cell in the current worksheet | New Users to Excel | |||
referring to formula in a non active cell from active cell | Excel Discussion (Misc queries) | |||
howto: saveas with file name from a cell in the current worksheet | New Users to Excel | |||
Excel 2007 (Trial) Active X Problems | Excel Discussion (Misc queries) |