Formatting CELLS

[stew]

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]

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

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

 

[David Biddulph]

Stew,

Would you please get your caps lock key repaired and STOP SHOUTING.