View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Formatting CELLS

Maybe you could insert the worksheet function =hyperlink().

=hyperlink("http://www.microsoft.com","click me")

stew wrote:

i HAVE FORMATTED MY EXPENSES SPREADSHEET TO ALLOW fORMULA TO BE PROTECTED AND
HIDDEN AND ENTRY CELLS TO BE UNLOCKED. I HAVE LEFT OPEN A CELL INTO WHICH A
HYPERLINK HAS TO BE INSERTED HOWEVER WHEN SHEET IS PROTECTED THE HYPER LINK
CANNOT BE INSERTED . iS THERE A WAY ROUND THIS

THANKS FOR LOOKING

STEW


--

Dave Peterson