Results 1 to 5 of 5

Hide/Unhide Scroll Bars Code for Specific Sheets

Threaded View

crazyforexcel Hide/Unhide Scroll Bars Code... 12-21-2019, 09:09 AM
KOKOSEK Re: Hide/Unhide Scroll Bars... 12-21-2019, 09:15 AM
crazyforexcel Re: Hide/Unhide Scroll Bars... 12-21-2019, 09:20 AM
KOKOSEK Re: Hide/Unhide Scroll Bars... 12-21-2019, 09:26 AM
crazyforexcel Re: Hide/Unhide Scroll Bars... 12-21-2019, 09:28 AM
  1. #4
    Forum Expert KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    2,765

    Re: Hide/Unhide Scroll Bars Code for Specific Sheets

    You can set :

    Sheets("SomeSheetName").ScrollArea = "A1:A100"   'set rows according to your needs
    then can't be scroll down more than 100 rows but you have to be sure that all necessary rows are visible for users.
    Check Budget tab in attached file (there is no possibility of scroll or event click anywhere but if you resize window you can't see full table).
    Attached Files Attached Files
    Last edited by KOKOSEK; 12-21-2019 at 09:29 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Macro to hide/unhide user defined specific sheets
    By LeanAccountant in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-15-2018, 11:02 AM
  2. [SOLVED] VBA code to hide/unhide rows on 2 different sheets-HELP
    By bugdout in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-13-2017, 04:03 PM
  3. VBA code for Checkbox to hide and unhide rows by a specific name
    By NichlasO in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 03-19-2017, 12:38 PM
  4. Inputbox with password to hide/unhide specific sheets in workbook.
    By Tona in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-29-2015, 07:41 AM
  5. [SOLVED] Hide & Unhide specific sheets Macro Check and Advice
    By huard in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-07-2014, 07:21 AM
  6. [SOLVED] Hide Unhide specific sheets with cell value
    By aksnave in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-27-2012, 06:06 PM
  7. How to HIDE/UNHIDE Specific Sheets Using a TOGGLE Button?
    By e4excel in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 04-16-2011, 02:58 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1