Programming

Preventing "Protect Workbook"
Is there any way to disable the "Protect Workbook" button in Excel 2007?? Just curious if there any ways to prevent this option. The reason I'm asking about this is because my workbook contains lots of VBA code in which I set a sheet's "visible" property to "xlVeryHidden" or "xlVisible". So, if someone prote... 9 Feb 2010 07:17

Excel 2007 Not Drawing Correctly
Hi all I have some code to select shapes grap their top, left positions and then move shapes to suit. When I run it through excel 2003 it works fine, however excel 2007 doesn't position them correctly. Has there been any code changes that I need to be aware of. Any answers would be greatly appreciated Ja... 10 Feb 2010 04:30

how to detect if an addin is running
Hi, I am trying to write a Com-Addin for MS Excel and I wanted to know if there was any method I could use to determine if the addin was loaded and running? GW. ... 8 Feb 2010 19:09

Last row + rank help
I am running Excel 2003 and I am trying figure out how I can find the last row of data in one sheet and use that range to calculate rank on a separate sheet. ... 10 Feb 2010 14:34

Trouble with Cutting and Inserting a Range
I'm trying to reformat a report I have to run a lot, but I keep getting an error whenever I try to cut a range, then insert the cut cells at another location. Here's my code: Sub ReformatEEList() Dim CutOff As Long Application.ScreenUpdating = False Range("C5").Insert Shift:=xlToRight Rang... 8 Feb 2010 12:16

Ribbon callback from built-in buttons to trigger additional code
I want to provide one of the built-in buttons on a new ribbon and leave it to function exactly as it does on the default ribbon, but I want to know when the user clicks it. Specifically, I want to provide a button which allows the user to draw a connector line but then trigger some other code after the connector h... 8 Feb 2010 08:53

reference excel interop assemblies
We have created a console application that reads data and images from an excel sheet and it runs fine on our development platforms, but when we moved it to the server, it fails. Does excel need to be installed on the servers for this to work? ... 8 Feb 2010 08:53

Call macro after "macros are enabled"
Hi there, I am quite a noob in programing VBA so this question might seem really trivial to some of you, but unfortunalty it is not for me ;) I want to start a macro, after the user has accepted the default security message, excel is showing. Disabling this message is not possible, because the sheet has to ... 8 Feb 2010 04:32

How do I make excel say a phrase when hitting a certain goal in a
I'm making a numbers reporting sheet for my retail store, and would like the sheet to automatically say "Great Job Hitting AROD Goal!!!" when another cell hits above $30.... Is this possible? ... 7 Feb 2010 17:37

Method to group lines
Hi, I have this kind of sheet: 1?? AA1 2?? BB1 3?? CC1 3?? CC2 3?? CC3 3?? CC4 3?? CC5 2?? BB2 3?? CC6 3?? CC7 3?? CC8 1?? AA2 2?? BB3 3?? CC9 3?? CC10 3?? CC11 every rows it's a cell. The first number is the level of depth. How can I group group the rows by the level? I need to use the function ... 7 Feb 2010 05:25