Search results for query: *

LamerThanU, If you click the button quickly, it does allow around 8 clicks. However, if you click slowly, the code I wrote will not allow more than 5.

I won't pretend to be great at coding, but this works: Private Sub CommandButton1_Click() Static cmdCount As Integer ' don't forget that this variable (cmdCount) will start at zero ' >= 4 will get you 5 button presses If cmdCount >= 4 Then MsgBox ("Don't press my button!")...

The last cell was actually exactly what I expected [cells(100,11)]. There were no links, graphics, pivot tables (I know they're useful but I hate those damn things!) or named ranges referring to other workbooks. There really wasn't much of anything - this was a really simple spreadsheet. As I...

Thanks Gavin! For some reason my first sheet in the workbook was +33 Mb without any data. Couldn't figure out what was hidden in the sheet, but I deleted it, created a new sheet with formats\formulas\objects copied from another sheet. Now the whole workbook is only 206 Kb even with all the data...

I wrote some vba code for a co-worker yesterday. The Excel workbook consists of 8 sheets, minimally formatted with two labels and a vba textbox at the top. There are 100 rows and six columns that are visible (not hidden). There are only three columns with formulas in them and all return a...

Thanks Skip! (I have to admit that I feel stupid.)

I have been working on this for a couple days and cannot figure it out! Details: I have a large document that I need to separate and print by Technician names. I have working code that counts the # of pages for each technician and then calculates which pages to print, but I cannot get VBA to...