Double whammie

ashie · Apr 23rd, 2002, 12:18 AM

Hi - two easy ones

Is it possible to create a 'hyperlink' between worksheets in the same workbook?

And...

Can I protect a column from the autocorrect function?

Thanks!!

Ashie Uk

anno · Apr 23rd, 2002, 12:37 AM

to create a hyperlink, press ctrl+k, go to insert menu>insert hyperlink, or use the hyperlink button (globe with chain links) on the standard tool bar. all three will bring up a dialog box to create a hyperlink. the 'named location in file' is the bit you want. press the browse button and select the cell ref you want.
sorry but can't help with the autocorrect thing

[ This Message was edited by: anno on 2002-04-22 23:38 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 23rd, 2002, 12:18 AM	#1
ashie New Member Join Date: Mar 2002 Posts: 18	Hi - two easy ones Is it possible to create a 'hyperlink' between worksheets in the same workbook? And... Can I protect a column from the autocorrect function? Thanks!! Ashie Uk

Apr 23rd, 2002, 12:37 AM	#2
anno Board Regular Join Date: Feb 2002 Posts: 202	to create a hyperlink, press ctrl+k, go to insert menu>insert hyperlink, or use the hyperlink button (globe with chain links) on the standard tool bar. all three will bring up a dialog box to create a hyperlink. the 'named location in file' is the bit you want. press the browse button and select the cell ref you want. sorry but can't help with the autocorrect thing [ This Message was edited by: anno on 2002-04-22 23:38 ]