Search results for query: *

I got the idea..i will try it ..thank you all for yr time...

"you'd have to disable the macros... menu item"...which Menu item, like how do I disable the MAcros from the Excel or VBA? Where?... another question , If I disable the MACROs, then the Macros will not work , or?

The problem with setting the DrawingObjects parameter to False is that then any one can change the Text on the Button PObjects or even delete the Buttons.....and this is the reason the Sheet has to be protected from the start, so that no Change is possible, actually it has to be protected just...

So, Mike........how do I check it? got any IDEA? :)

So, Mike........how do I check it? got any IDEA?

"Even after this, the user can still get to VBE by choosing "Macros", then hitting the "Edit" button. You'd have to prevent access to the "Macros" menu item as well, which is getting kind of drastic..."....can you Disable this Edit Button also?

Hi.. I tried your way....Still problems. Actually I have a Button on a Excel Sheet. And, there is .OnAction with the Button objest. So when I click the button on the Excel Sheet, a MAcro called "Text" will run. Now thios macro is like this: Sub text() Dim Msg, Response...

Hi... I am using a Macro that uses This line and I get runtime error in this line when I use this Macro after protecting the Sheet(I am not Copy-Pasting, so there might b a little error in the code here, but it explains the problem I think ): " ActiveSheet. Protected DrawingObjects :=...

Hi I am using ActiveSheet. Protect OR ActiveWorkbook.Protect to Protect all the Data in the Workbook.........now, I have some Shape Objects and I want to be able to click them, so that after clicking some MACROs trigure.But I should not b able to change DATA on those objects. Now, if I...

HI all I have VBA Macro running behind Excel..now, How do I Hide access to the VB IDE? VB Should not open even if someone presses ctrl-F11 .......the IDE should be totally hidden..how DO i do that? Also, how can I check whether Excel is already running before I use...

Hi Thanx I think it will return me the type of the shape, right? but I need t´he name of the shape, like "Rectangle 1" or "Rectabgle 4" or "Oval 6" etc... Is it possible?

Hi All Suppose I have a 15 of shapes (Rectangles, Ovals etc.) . Now I think the shapes are marked as Shapes("Rectangle 1"),Shapes("Rectangle 2"),Shapes("Oval 3") ....serially.........now my question is how can I make a Macro that is intelligent enough to identify...

Hi CAn i use .onAction here? how? nimo

Hi Tranpkp, The answer you gave on Seeing the text on the Rectangles was really helpful. But one thing I still cannot decide. It is possible to have 100s of rectangles like this. So clicking a rectangle, then assiging bring to Front is not possible......the whole thing has to be...

Dear Tranpkp and aMemeber: Thanks a lot for all the time and effort you have given on the problem. I am really grateful to you both. Currently I am in a different place and cannot test the solutions you have provided. I will try them tomorrow, hopefully. Another question, can I use these codes...

Hi aMember I am using '2000.....so may b there is a problem for that......anyway, if I have 30-40 rectangles, then it is not possible to assign a macro to all the shapes....how I can I do it dynamically so that once the Macro is running, all the shapes are assigned the macro and when I click...

Dear aMemeber: I tried your code........but it did not work in my PC...did it work on yr PC? Nimo

Hi Tranpkp Thanx a lot. This works great from the VB IDE, I mean if I run the Macro from VB, I can get the Text of a rectangles[depending on the value of i on Shapes(i)]. Also it works fine if I assign this macro to a rectangle by right clicking.But if I have 30 Rectangles like this, then it is...

Dear aMember: Yes, u r right. I have to trigger a event when I click the rectangles or drag mouse over it. So, can you give an idea how I can trigger an event and then see all the texts inside the rectangle automatically when I click a rectangle or drag mouse over it? Answering your 2nd...

Hi All.. Suppose I have a Excel Sheet where I have some Rectangles. Inside those rectangles I have some texts. But normally those texts are not visible because the rectangles are small in shape. To view the texts, I have to click, then enlarge the rectangles. My question is, how can I write a...