Image Macro Help!

  • Thread starter Thread starter bcap
  • Start date Start date
B

bcap

Hi,

I am looking for help to create a macro but am not sure if what I want
to do is possible.

Is it possible to:

(1) Have an image open on the fly from a drive directory instead of
storing the image permenantly in a cell
(2) Is it possible to automatically have the (A1) field on ANY
worksheet by default?

Thank you for your time and thoughts!!!!
 
Hi,

I am looking for help to create a macro but am not sure if what I want
to do is possible.

Is it possible to:

(1) Have an image open on the fly from a drive directory instead of
storing the image permenantly in a cell
(2) Is it possible to automatically have the (A1) field on ANY
worksheet by default?

Thank you for your time and thoughts!!!!
Click to expand...

Hi,

For the images you could add a hyperlink instead of the picture
itself.

I assume you mean you want A1 to be selected when you move to the
worksheet.
If that is correct then you add the following code to your workbook.

Private Sub Workbook_SheetActivate(ByVal Sh As Object)
Sh.Range("A1").Select
End Sub

hth

Regards

David
 
Back
Top