View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Peter Atherton Peter Atherton is offline
external usenet poster
 
Posts: 31
Default 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!
.