Desktop shortcuts

  • Thread starter Thread starter andrewn
  • Start date Start date
A

andrewn

Can you create a desktop shortcut that opens an excel spreadsheet an
shows you a specified cell?

Andre
 
Andrew,

A shortcut to open the workbook is the easy part, and I suppose you know how
to do that.
The other bit, selecting a specific cell, is not something you can do from
the shortcut. For that you need a couple of lines of VB code in the
Workbook_Open event, something like:

Sheets("Sheet3").Activate
Range("B6").Select

HTH,
Nikos
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top