Search results for query: *

I have a spreadsheet that has all cells requiring operator entry colored yellow. I'd like to create a macro/button combination that will clear only those cells when clicked, but preserve the data in all other cells. Do I need to protect all other cells and just "clear unprotected...

I have had this problem when assigning a macro to a button- sometimes it will add the workbook reference, sometimes not. When it does, it tries to open the same workbook and gives me an error. I have another macro in the same workbook that it does not attach the workbook reference to and it...

I would like to return to my sheet after displaying a user form, but it just returns me to the VBA page (after flashing the sheet but not retaining it). Any ideas why this is happening? Thanks for any help you might offer..I'm stumped. John Here's my code: Sub eMD()...

I need to select a row in a worksheet where the row is determined by a variable.. rows(variable:variable).select does not work. I am using Cells(variable).select, with the column number set to 1, but then the row selection goes away when I move to the right in the spreadsheet. Any suggestions...

I have a macro that needs input from the operator that is found on another sheet. I want to display this sheet with the appropriate row highlighted, allow the operator to "Cursor right or left", record the value in the appropriate cell, then have a way for the operator to return to...

I have a spreadsheet with a macro that I have created a custom button for, but would like to execute the macro when the spreadsheet is opened. Then I'd like to be able to re-execute it (if necessary) using the button. Is this possible? thanks John

I created an icon using the iconeditor. Now how do I change the shortcut's icon? The only way I know of to create a shortcut is through Explorer, click on the file, then File/Create Shortcut. This of course creates an Excel shortcut. How do I go in now and assign my own icon? thanks again. John

Zathras- Thanks so much for your help. I downloaded the iconeditor. John

OK..but how do I create the .ico file? John

I have a few spreadsheets that have macros to do different things. Is there a way to change the desktop icon to include my own bitmap file? thanks John

Can anyone recommend a good reference book for VBA/Excel? I have Reed Jacobsen's Step-by-Step Excel 97 Visual Basic book, which I have found very helpful. However, I am looking for something that is more of a reference for VBA commands and syntax, with examples. A quick search at Amazon and...

Nath- Thanks alot for responding. I'm having syntax problems I think. The name for my string is SCDMAX The name of the workbook is electrons opinnew The name of the sheet is eCALC The location of the value of A is E9, and the location where I want to put B is F9 So I wrote SCDMAX =...

I need some help on an Operator Interface in Excel. I want to say to the operator, "The value for Variable A is XX; Please enter the value for Variable B". Variable A is retrieved from a cell reference, and Variable B will be then stored in another cell reference to be used in a...