visibility

Greetings 1-How delay paste until merge shapes function in red color 2- it is work well if remove pptApp.Quit ' close Power Point 3- to declare Sld as object to avoid select Microsoft Power point Reference Sub CombineShapes() Dim WB As Workbook Dim WS As Worksheet Dim Shp As Shape...

I have a spreadsheet with multiple salespeople listed. Each row has a different seller's name and other sales data. It has very private data related to each sellers performance and pay. Is there a way for me to share this file with all sellers listed without going through all the work of...

Hi - Sorry if breaking protocol here, but I posted to an old post this morning which probably doesn't have any visibility at this point. I placed the URL below and would appreciate if someone could review and reply to the inquiry. Thanks in advance...

I am using a "Workbook_BeforeClose" operation to hide all worksheets except one. This is working fine for now but as I move through the process, I want to be able to change which sheets are visible. Within the application, I have a login in function to control visibility but when the workbook...

I am running Excel 2010 on a Windows 64-bit machine. I have a workbook with several worksheets, each of which contains data about a different folder on my file system. I have a general code module that contains VBA code that is used across all of the worksheets. It works fine. But I have...

Hi all,, I am fairly new to VBA, I have been trying to write a code that changes the visibility of a text box based on changes of selection of a dropdown list. Basically, I want to check if the user chose a specific option from the dropdown list, if he did, I want to make the text box visible...

Hi guys, this is my first post. So I've been trying to set up an order form that has drop down menus and vlookup data with a separate sheet for the lookup tables. I want to set up a bunch of macros for each different option so that when a specific option is selected in each of the drop down...

Hi, I'm trying to writea code that doesn't require stepping into vba to effect the outcome of themacro. Currently, I have acode that toggles the visibility of an array of sheets if the target cellmatches certain conditions (blue or dark blue fill). This code works great.However, I want to...

Is it possible to toggle the visibility of an array of worksheets rather than one worksheet at a time? I know this code wouldn't work if you tried, but I'm thinking something like this: Dim ShtNames as Variant ShtNames = Array("01", "02", "03") ShtNames.Visible = True I know I could run a for...

Helloo, I would like to create an automatic and manual setting in my latest spreadsheet. The operation mode is a drop down list. When Automatic Input is selected, then the engine type and load will be a drop down list also. However, when the Operation Mode is in Manual Input, is there a way of...

Here is one to chew on, and if you have seen this and or even resolved this, maybe you can help. I have 7 hidden worksheets that have a checkbox control for visibility (on/off). Why is it, or would it be; that when checked the actual size of the check box gets smaller and graphically the...