Avatar of Rayne
Rayne
Flag for United States of America asked on

Lock view it accordingly

Hello All,

I have a VBA issue. Is it possible to toggle freeze-rows at the column headers of two data sets in the same sheet? Like:
 if I put 1 in cell K2, then freeze panes happens at D5.
if I put 2 in cell K2, then freeze panes happens at D22.

Thank you
R
lockFreezeIt.xlsx
Microsoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
redmondb

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
redmondb

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Rayne

ASKER
Thanks Brian
:)
Thats great
redmondb

Thanks, Rayne.
Your help has saved me hundreds of hours of internet surfing.
fblack61