visible = false

This is a copy macro that copies down based on user input from a pop up box. The issue is that when the excel sheet is filtered it will copy the filtered out data. How can this be modified to only count visible cells? Appreciate the assistance. Public Function CSOfSelection() As String Dim sOut...

Hi there, Trying to get this code to work but not having much luck. It currently does nothing. Can anyone see where I am going wrong please? Thank you! Private Sub Worksheet_Change(ByVal Target As Range) If Target = Range("d8") = 1 Then...

Hello all: I am creating a VBA workbook with UserForm to allow users to input data. I do not want the workbook to be visible to the user and have used "application visible=false" code. Everything appears to be working just as I want, however, I do not want to add a button/code the userform to...

Hi, In a pivot table created through vba there is Pivotfield with dates (DD.MM.YYYY). I grouped them with months and years and showed all items. Worksheets("Pivot_Tabellen").PivotTables(TableName).PivotFields("UTC Date").DataRange.Cells(1).Group Start:=True, End:=True, _...

Hey everyone, When my main workbook loads, it opens a second worksheet which holds data with has visible = false. I am trying to find a way for a macro run in my first workbook, to make the second workbook come visible again. I can use Ctrl G, in the "immediate" window and type...

Hey everyone, This has been bustin my balls all day. I have a workbook which when opened, also opens another workbook which has visible = false set. When i exit the main workbook, the other workbook does not close. I have tried multiple things to get it to close without luck. I need a...

I have a workbook that, upon opening makes the application invisible and opens it's userform: Private Sub Workbook_Open() Parent.Application.Visible = False UserForm1.Show End Sub There is a button on the form to unhide the parent application again, in order for users to modify the sheets...

Basic set up is I have a userform with a textbox & button. Put text in the box & click the button, It calls sub FNN_lookup(FNN). This sub have the "ieApp.Visible = False" line but internet explorer still ends up being visible. Any Ideas as to why? the sub has been tested without the userform and...