View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Nigel Nigel is offline
external usenet poster
 
Posts: 923
Default Load userform & deselect it

After loading and showing the user from select a location on the sheet in
question.......

UserForm1.Show vbModeless
Sheets(1).Range("A1").Select

--
Cheers
Nigel



wrote in message
oups.com...
Dear All,
I was wondering is it possible via macros to load a userform & deselect
it so that users can scroll in worksheet immedietely. Currently after
loading the userform I have click the worksheet before I can scroll
with arrow keys.

TIA,
julian