VBA Script in Excel

[luv2bike2]

I am not sure if this is where i should be (i hope so, if not please let me
know where to post this and i will do so).

I have followed the instructions from the web page www.rondebruinnl/code.htm
on setting up Option Explicit in every module and it has worked for several
users however there is one user that it is not working.

My users use Terminal Server to access programs. Everyone has access to
Excel 2003.

the issue that i am having with setting up VBA Script is as follows:

I go into Excel/tools/Macro/Visual basic editor
once in there I go to Tools/ Options and check off Require Variable
Declaration than OK.
i would get Option Explicit at the top of the personal .xls sheet1(code)
however this one particular user I do not get that.

What could be wrong?


Thank you,

 

[Doug Robbins - Word MVP]

You are in the wrong place here as this newsgroup is for the use of VBA in
Word. Microsoft.Public.Excel.Programming would be a more appropriate
newsgroup for questions concerning Excel.

However, you can just type Option Explicit at the top of the Code window
before anything else.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[luv2bike2]

thanks for your assistances.

I kind of thought i would be able to do that but just was not 100% sure.

Thanks,