Recent content by AcousticalConsultant

I think I'd prefer to go back to my initial approach (re-directing the commandbar actions), but I need it to be more robust for distribution on other computers. Anybody got some ideas?

I've been working at creating a solution for my needs, but I've concluding that it's just not working this way. It makes it very difficult when the user selects "undo". If the user undoes an "insert row" event, and the selected cell when the undo is initiated happens to be above the inserted...

That helps. Thanks Skip. It'll require some tweaking to suit my needs, but it's certainly a start, and it'll help make the code more compatible.

Well, that was my initial concern - but it probably won't matter much. So if I were to explore that method, I know that I can track the target range, but how can I trace whether the change was an 'insert row' event?

Hello, So essentially what I am trying to do it trap an "insert row" event so that I can prevent it on specific lines, but allow it on others. I know that there is no specific event to trap for insert rows, so we have to go about it another way. One way is to monitor the Worksheet_Change...

Hi, I have a database in Excel with entries on single rows. I have developed a userform to display the content of individual entries and allow the user to make changes. There are some calculations involved in the display so when the user makes a change to one of the properties, the results...

I thought I had tried that, but couldn't seem to get it to work. I tried it again after reading your post, and now it works... magic! I must be tired. Thanks Skip! For reference, here is the property: activesheet.rows(n).hidden

Hi, I'm trying to find a property which lets me know if a row has been "hidden" by a filter or not. I know that I can check the autofilter mode to determine if the autofilter is active, but how do I verify individual rows? Thanks for the help! AC

Sugarflux, Great! That's exactly what I needed. Works perfectly. Thanks! AC

Hello, I was wondering if anyone knew how to format text (e.g. make bold) within a comment box in Excel using VBA. I want to make certain portions of the text bold. It's easy to do manually, but with the "Macro recorder" it doesn't write any code for the formatting. Unlike the 'cells'...

Skip, I had looked into that already, but I was only able to make every other gridline bold because I was using a line chart. Now I've changed it to an XY Scatter Plot and I realized that you could define the MAJOR and MINOR gridline spacings. The only thing now is that my x-values are bogus...

The reason for putting lines on the graph is because we need every third vertical gridline to be a thicker lineweight. In Excel you can configure all gridlines (horizontal or vertical) to a single lineweight, but not every individual gridline. Therefore, we superimpose a line on top of the...

We are using excel to plot graph; in the graph sheet we add some lines and text. (1) for the lines, in the "format autoshape menu - size" when correcting the width to 0 cm and clicking ok, the value for the width is still 0.01 cm (2)when ploting the graphs, the lines and text box are always...

Fumei, That's excellent! Thanks for the tip! Pascal

Works beautifully TCarpenter... Thanks!