Mrrrr's Forum (VIEW ONLY)
Un forum care ofera solutii pentru unele probleme legate in general de PC. Pe langa solutii, aici puteti gasi si alte lucruri interesante // A forum that offers solutions to some PC related issues. Besides these, here you can find more interesting stuff.
|
Lista Forumurilor Pe Tematici
|
Mrrrr's Forum (VIEW ONLY) | Reguli | Inregistrare | Login
POZE MRRRR'S FORUM (VIEW ONLY)
Nu sunteti logat.
|
Nou pe simpatie:
draghici_elena2000
 | Femeie
24 ani
Dambovita
cauta Barbat
24 - 62 ani |
|
TonyTzu
Moderator
 Inregistrat: acum 12 ani
Postari: 252
|
|
The cause of this is that I used 2 windows for the same file; the 2nd window uses default windows settings. Make sure that the windows you save last is the one with freeze panes activated, otherwise they will be removed and next time you open the file freeze panes won't be active anymore.
Leave the original window (FreezePanes.xlsx:1) open, and close the other windows (FreezePanes.xlsx:2).
Read here:
***** Freeze panes on workbook open --- in multiple sheets --- might not work *****
Source for next code:
Having to set freeze panes in multiple sheets, I've used the following code in ThisWorkbook:
Private Sub Workbook_Open()
Sheets("Sheet1").Range("A4").Select
ActiveWindow.FreezePanes = True
Sheets("Sheet2").Range("A6").Select
ActiveWindow.FreezePanes = True
End Sub
Scratch that.
I can't set multiple freezes on workbook open because I would get an error as it can't select multiple cells in multiple sheets all at once.
|
|
| pus acum 5 ani |
|