Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Stopping A Sheet From Scrolling
Hi
I have a worksheet and all the information needed for the user is available on the sheet being opened - is there any way to stop this one sheet in the workbook from scrolling vertically and horizontally Any help much aprreciated Cheers ----- Mully |
#2
|
|||
|
|||
One way to consider ..
Supposing the info is all within say, A1:H20 Select I21, click Window Freeze Pane -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "mully" wrote in message ... Hi I have a worksheet and all the information needed for the user is available on the sheet being opened - is there any way to stop this one sheet in the workbook from scrolling vertically and horizontally Any help much aprreciated Cheers ----- Mully |
#3
|
|||
|
|||
Hi Max
Sorry about this missed it off earlier question - we had already done what you suggested and some smart ass worked that out pretty fast and info we didn't want them to have access to - including unhiding columns and rows - and as we have to use an easy remember password on protect sheet it was a doodle for them. Is it possible to use a macro in VBA that locks the sheet on opening it within the workbook and at the same time stops them scrolling Cheers ---- Mully "Max" wrote: One way to consider .. Supposing the info is all within say, A1:H20 Select I21, click Window Freeze Pane -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "mully" wrote in message ... Hi I have a worksheet and all the information needed for the user is available on the sheet being opened - is there any way to stop this one sheet in the workbook from scrolling vertically and horizontally Any help much aprreciated Cheers ----- Mully |
#4
|
|||
|
|||
Perhaps you could try this sub
(placed in the "ThisWorkbook" module): Private Sub Workbook_Open() Worksheets("Sheet1").ScrollArea = "A1:H20" End Sub One way to go to the "ThisWorkbook" module: Right-click on the Excel icon just to the left of "File" on the menu Choose "View Code" This will bring you direct into the "ThisWorkbook" module Delete the defaults and paste the code there -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "mully" wrote in message ... Hi Max Sorry about this missed it off earlier question - we had already done what you suggested and some smart ass worked that out pretty fast and info we didn't want them to have access to - including unhiding columns and rows - and as we have to use an easy remember password on protect sheet it was a doodle for them. Is it possible to use a macro in VBA that locks the sheet on opening it within the workbook and at the same time stops them scrolling Cheers ---- Mully |
#5
|
|||
|
|||
Hi Max
Worked first time - Spot on - that will stop the smart ass finding our daily turnover and customer details - Going to change the password on a daily basis so they will have to ask to unprotect the sheet - its a pity we can't put about 10 passwords on the sheet and let it change on a daily random basis. Anyway thanks again your help is much appreciated Mully "Max" wrote: Perhaps you could try this sub (placed in the "ThisWorkbook" module): Private Sub Workbook_Open() Worksheets("Sheet1").ScrollArea = "A1:H20" End Sub One way to go to the "ThisWorkbook" module: Right-click on the Excel icon just to the left of "File" on the menu Choose "View Code" This will bring you direct into the "ThisWorkbook" module Delete the defaults and paste the code there -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "mully" wrote in message ... Hi Max Sorry about this missed it off earlier question - we had already done what you suggested and some smart ass worked that out pretty fast and info we didn't want them to have access to - including unhiding columns and rows - and as we have to use an easy remember password on protect sheet it was a doodle for them. Is it possible to use a macro in VBA that locks the sheet on opening it within the workbook and at the same time stops them scrolling Cheers ---- Mully |
#6
|
|||
|
|||
You're welcome !
Thanks for the feedback -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Impoting data from Sheet 1 to Sheet 2 | Excel Discussion (Misc queries) | |||
relative sheet references ala sheet(-1)!B11 so I can copy a sheet. | Excel Discussion (Misc queries) | |||
linking multiple sheets to a summary sheet | Excel Discussion (Misc queries) | |||
Function to automatically insert a new sheet as a result of data entry? | Excel Worksheet Functions | |||
Naming & renaming a sheet tab | Excel Worksheet Functions |