VBA Scroll to left side of freeze frame

**KerahJoy** · 10-23-2023, 04:54 PM

I am able to Select a cell with VBA code but looking for one to move a freeze frame as far left/top as possible. I would like cell G2 to show when user opens the wb.

**protonLeah** · 10-24-2023, 04:15 PM

Right click the sheet tab.
Select "View Code"
When the VB Editor opens paste the code below into the code pane:

Please Login or Register  to view this content.

**Artik** · 10-25-2023, 07:48 AM

In addition to the code in the "Append" sheet module (with the code name Sheet1), I would also add code in the ThisWorkbook module:

Please Login or Register  to view this content.

Artik

VBA Scroll to left side of freeze frame

LinkBack

Thread Tools

Rate This Thread

Display

VBA Scroll to left side of freeze frame

Re: VBA Scroll to left side of freeze frame

Re: VBA Scroll to left side of freeze frame

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Data shift from right side to left side

[SOLVED] How can I change Chart.Axes(xlValue) from left side to right side ?

[SOLVED] Why Minus (-) Symbol Coming Right Side Instead of Left Side ???

[SOLVED] How to shift numeric number from left side to right side of a particular word

[SOLVED] How to move data from right side to left side, please check the attachment

Freeze Panes with Left Side Scroll

[SOLVED] Freeze top and left side

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions