Image Macro Help!

[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!!!!

 

[David Heaton]

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,

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