Strange Problem

Carolyn · Apr 16th, 2002, 01:32 PM

I have a spreadsheet set up that co-workers go in and enter data into. The spreadsheet as well as workbook are protected. They only have access to certain cells to enter their data into. However, lately the strangest thing hsa been occurring. After they enter the data, save and close out, the spreadsheet hides all of it's columns all the way out to the far right. All I see on the screen is grey until I go and unhide all columns. I have no explanation for this. Can anyone help? Thanks in advance.

Jack in the UK · Apr 16th, 2002, 01:33 PM

do you have macros in the WkBk??

Carolyn · Apr 16th, 2002, 01:39 PM

[quote]
On 2002-04-16 12:33, Jack in the UK wrote:
do you have macros in the WkBk??

I had one macro in the workbook. I have actually since gone and deleted the macro although I never saw any problem in the code. I am still having the same problem.

kinkyparamour · Apr 16th, 2002, 02:26 PM

Check under view to see if you are using page break preview. This will turn the screen gray.

Denny

Jack in the UK · Apr 16th, 2002, 02:29 PM

whwn you open the WkBk do you get macro warning?

Carolyn · Apr 17th, 2002, 05:50 AM

I have Macro Virus Protection turned off. Others entering data in separate computers have it turned on. Is that what you are talking about?

Chris Davison · Apr 17th, 2002, 01:12 PM

try print preview and look at the option between "margins" and "close"

does it say "normal view" ?

if it does, click on it back to normal view.... someone must have toggled it to "page break preview"

(At liesure, check this option out though, it's very very useful)

Just thought I'd re-iterate Denny's original suggestion just in case Jack's normally very useful help doesn't work

ps Jack - Did you get my F1 quiz ?!

Carolyn · Apr 17th, 2002, 01:22 PM

I wish it were as easy as page break preview.
I have checked all of the simple options. I am beginning to suspect a virus. There is one particular computer that after it saves the worksheet is when the problems occur. It is hiding all of the columns upon saving. When I return to look at the sheet, it is also unprotected. I really have no idea what is going on. Does anyone know of a possible virus that could do this?

Chris Davison · Apr 17th, 2002, 01:25 PM

okie dokie...... I'd probably bow out on this now then.... Jack's yer man for viruses and stuff

sorry

Carolyn · Apr 17th, 2002, 01:26 PM

Thanks for trying though. Appreciate it.

Apr 16th, 2002, 01:33 PM	#2
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,064	do you have macros in the WkBk?? __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Apr 16th, 2002, 02:29 PM	#5
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,064	whwn you open the WkBk do you get macro warning? __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

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

Apr 16th, 2002, 01:32 PM	#1
Carolyn New Member Join Date: Apr 2002 Posts: 7	I have a spreadsheet set up that co-workers go in and enter data into. The spreadsheet as well as workbook are protected. They only have access to certain cells to enter their data into. However, lately the strangest thing hsa been occurring. After they enter the data, save and close out, the spreadsheet hides all of it's columns all the way out to the far right. All I see on the screen is grey until I go and unhide all columns. I have no explanation for this. Can anyone help? Thanks in advance.

Apr 16th, 2002, 01:39 PM	#3
Carolyn New Member Join Date: Apr 2002 Posts: 7	[quote] On 2002-04-16 12:33, Jack in the UK wrote: do you have macros in the WkBk?? I had one macro in the workbook. I have actually since gone and deleted the macro although I never saw any problem in the code. I am still having the same problem.

Apr 16th, 2002, 02:26 PM	#4
kinkyparamour Board Regular Join Date: Feb 2002 Location: Florida Posts: 82	Check under view to see if you are using page break preview. This will turn the screen gray. Denny

Apr 17th, 2002, 05:50 AM	#6
Carolyn New Member Join Date: Apr 2002 Posts: 7	I have Macro Virus Protection turned off. Others entering data in separate computers have it turned on. Is that what you are talking about?

Apr 17th, 2002, 01:12 PM	#7
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	try print preview and look at the option between "margins" and "close" does it say "normal view" ? if it does, click on it back to normal view.... someone must have toggled it to "page break preview" (At liesure, check this option out though, it's very very useful) Just thought I'd re-iterate Denny's original suggestion just in case Jack's normally very useful help doesn't work ps Jack - Did you get my F1 quiz ?!

Apr 17th, 2002, 01:22 PM	#8
Carolyn New Member Join Date: Apr 2002 Posts: 7	I wish it were as easy as page break preview. I have checked all of the simple options. I am beginning to suspect a virus. There is one particular computer that after it saves the worksheet is when the problems occur. It is hiding all of the columns upon saving. When I return to look at the sheet, it is also unprotected. I really have no idea what is going on. Does anyone know of a possible virus that could do this?

Apr 17th, 2002, 01:25 PM	#9
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	okie dokie...... I'd probably bow out on this now then.... Jack's yer man for viruses and stuff sorry

Apr 17th, 2002, 01:26 PM	#10
Carolyn New Member Join Date: Apr 2002 Posts: 7	Thanks for trying though. Appreciate it.