General Inquiry

Ok. How would I go about doing that ?

Thanks for your help. I believe i was not detailed enough as to what i would like done.

I basically want to create a shortcut in one file to open another file. I want the link to be placed on the Button. They are both excel files, both are located on the company's public drives.

It you are trying to open from one excel, another excel file, in that case you have to use

Workbooks.Open ("c:\this is that\myfile.xls")

First you have to create a routine

sub mysub()
Workbooks.Open ("c:\this is that\myfile.xls")
end sub

now right click on button, and choose assign a macro and choose this macro'

Other way can be that you use text as hyper link

So on a cell you can have some this like
2010 Forecast
now right click on the cell and choose hyperlink and add path and file name like
C:\Users\haadi\Downloads\book1.xls

thanks, it worked. Is there anyway to protect the button so that no one can delete it, or change the text. The spreadsheet that its in is protected, but you can still right click on the button and make changes.

never did that. But I would suspect that first you unprotect sheet. Then add the button and assign macro and then look into its properties (right click) to ensure that it is locked and then apply sheet protection. See if it works. Would you please post a message if it works

At least in 2007 when you try to protect a sheet, there is option about object. You want to disallow that for user