Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: nimo
  • Content: Threads
  • Order by date
  1. nimo

    Is there any way to solve this Protecting Shapes problem?

    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...
  2. nimo

    How do I Hide access to the VB IDE? VB Should not open

    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...
  3. nimo

    How do I recognize shapes?

    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...
  4. nimo

    Hi Tranpkp, The answer you gave

    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...
  5. nimo

    Enlarge and view data which is not normally seen

    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...

Part and Inventory Search

Back
Top