View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
sree kasi sree kasi is offline
external usenet poster
 
Posts: 3
Default Key Board Shortcuts

Hi,

I am new to Excel and VBA, I am looking for a keyboard shortcut to select
all worksheets in an excel workbook.

(Infact, i am planning to select all worksheets using a keeyboard shortcut
and then deselect the last worksheet, to delete all the selected worksheets.
I wish to use this, while i record a macro, to do this everytime i need to
update my file. Actually before running my macro, which would copy some
sheets from an open workbook, i need to delete these old sheets.)

Hoping for a reply and guidance soon,
Sincerely,
Sree