Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel - Missing Textboxes Weird!! 1

Status
Not open for further replies.

DAmoss

Technical User
Jul 23, 2003
169
GB
Hi,

I have an Excel worksheet which uses various cells and form textboxes to collect certain project information. The worksheet works great on all our computers bar one!

On this particular computer the textboxes all dissappear, even though any previous entered data can still be seen in a hidden data collection sheet.

All the computers have the Excel 2003 installed (fully updated), the same colour, macro and option settings, the same vba libraries installed, but still the text boxes won't show!

Does anyone have any ideas as to why this might be happening on this particular computer?

Cheers
 
Check the security on the problem machine.

In Excel, Tools > Macro > Security. If set to High or Very High, no macros/VBA will run. Setting to Low is a security risk, so set to MEDIUM.


[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.
 
What about other workbooks? Check Objects option in Tools>Options>View tab.

combo
 
Thanx guys for your quick replies!

It wasn't the Macro settings as this was set to Medium, but it is combo's answer, cheers for that!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top