visual basic editor

Hi all I want to protect my VBA code when the file is opened as read-only, such that the users will not even be able to click on the developer-visual basic or press Alt F11. In a word, the whole VBA will be locked, even they have their own files opened that have macro codes, they will need to...

I am trying to have data I enter in Col B (300 lines) auto sort Hig to low and can't seem to get it to work. Any Ideas? Private Sub Worksheet_Change(ByVal Target As Range) If Intersect(Target, Range("B1:B300")) Is Nothing Then Exit Sub Application.EnableEvents = False Me.Sort.SortFields.Clear...

Hi All - I would really appreciate your assistance with something. I have pre-printed stationary that I would like to add a pre-assigned invoice number to (say 100600). I need to write code that will increment the invoice a said number of times based on however many copies that I make. For...

Hello, We are using Excel 2007. I wanted to add the date of the last modification of the file to the printed pages, so I googled how to do it and found a useful answer on this from from 10 years ago. It said to press ALT+F11, then on the left side go under VBAProject, there go to...

I have a very simple macro that sorts a table. For no apparent reason, when I run the macro it automatically opens the Visual Basic Editor window. Any help?

Hello, First let me say that I am a beginner in Excel and stumped by a really important task. I have to find all duplicate records in 48,000+ rows and then concetenate values from a single column. I have 10 columns of data and want to find all duplicates by Email Address and then concatenate...

Anyone ever run into a situation where you open your VB Editor and the Properties Windows is not there? Even if you press F4 or click the icon in the Toolbar nothing appears? Don't really understand it since it just happened and was displaying before. I hope someone can help me out with this.

Hi, I've created a UserForm in Excel that feeds a workbook - I would like to create a user form that can create a separate worksheet (new document) based around the selection I make in the form. e.g. My form looks like this: <a href="http://www.flickr.com/photos/67298551@N07/6169185913/"...

Hi There, I have set up a really simple UserForm in VBA that populates a worksheet that is made up of 4 columns - I've included the code below: <a href="http://www.flickr.com/photos/67298551@N07/6165759057/" title="Table by digiteers, on Flickr"><img...

My code so far is....... Sub Ace1_Click() If IsEmpty(Range("B16")) Then Range("B16") = 11 Else Range("C16") = 11 End If End Sub All this does is if I press the relevant button "Ace1" it will display the value= 11 in cell B16, If i press this button again it will display the value=11 in cell...

I'm trying to assign a keyboard shortcut (Ctrl+Shift+C) to comment a block of code in the Visual Basic Editor. How do i go about doing this? I know there is a toolbar with a button for it, but **** the mouse... I want a keyboard shortcut! Thanks in advance...