Formatting CELLS
 

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

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

Formatting CELLS
 

Stew,

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

"stew" wrote in message
...
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