Gridlines & column/row headings off on other pc

[Guest]

Hi excel experts

I'm developing a spreadsheet and I want it to look like a word document as
much as possible so as not to scare the non-excel users. I found some great
code for turning off menus (thank you Bob Phillips) but now I want to know if
I use Tools-> Options-> View-> untick gridlines and row & column headings is
this computer specific or will it 'travel' with the spreadsheet? It appears
to be sheet specific which makes me think it will travel but I would like to
be sure before I send it off.

Oh and while I'm here I have used hyperlinks (ctrl+K) on autoshapes for
navigation from sheet to sheet: when I hover my mouse over they have the full
path of the document not just the sheet name so will they break? I have moved
the spreadsheet around on my PC and they seem to be ok but I don't want to
send it & look like a complete idiot

Thank you

Lucy
--
MOS Master Instructor
www.aneasiertomorrow.com.au

If this post answered your question please let us know as others may be
interested too

 

[Guest]

hi,
1.anything done in the options window, is pc spicific and not file specific.
it will not follow the file. it is considered a customization and custom
pereverences vary from user to user so on open a file pick up the current
pc's custom features.
2.have you tried emailing the file to another pc as a test. I'm not sure on
this one but i would test this to make sure because it may change paths on
your pc but i don't think it will when it's opened on another pc.

Regards
FSt1

 

[Guest]

Thanks for the quick response.
1. Do you know of any way to force the option on their PC for this
spreadsheet (like the menu macro)
2. I'm a sole trader with only one computer - I was trying to avoid sending
this to the client to test - doesn't look that professional

Lucy
--
MOS Master Instructor
www.aneasiertomorrow.com.au

If this post answered your question please let us know as others may be
interested too

 

[Gord Dibben]

Fst1

What do you consider as the "options window"?

Many Tools>Options items are Window specific, sheet specific or workbook
specific.

Gridlines enabled/disabled and Row and Column Headers are seheet specific items.


Gord Dibben MS Excel MVP

 

[Guest]

hi,
yes i do. anything you do with the mouse or keyboard can be done with a
macro. but i don't recomend that you do it. it is impolite to mess to someone
esle's pc. you may be messing up their customizations. and some consider such
actions as a virus. you are not modifing a file. you would be modifing their
entire pc. all file that they open would have the same options. you might be
able to "undo" your customizations at file close but it would present
problems if they had more than one file open. and you may not be able to
reset their customizations if they had special customizations forcing them to
redo their pc with their perferences.
as to the second issue, i see your delema. but as stated, i'm not sure on
this one. experience leads me to believe that the path will not automaticly
reset on another pc. seek another opinion on this.

regards
FSt1

 

[Guest]

thanks gord,
I don't know where my mind was on this one. i think i may have been up too
long.
mind in ditch.

sorry
FSt1

 

[Gord Dibben]

Happens to all of us<g>

Gord

thanks gord,
I don't know where my mind was on this one. i think i may have been up too
long.
mind in ditch.

sorry
FSt1

 

[Guest]

Just in case anyone is interested:
Yes hyperlinks did work on another computer
Yes hiding gridlines & row column headings is spreadsheet dependant so did
travel (but don't worry FSt1 it didn't affect any of the other settings or
other spreadsheets)

Lucy
--
MOS Master Instructor
www.aneasiertomorrow.com.au

If this post answered your question please let us know as others may be
interested too