Toggle button

[arunakumari02]

I have a grid 4 x 5 and named each cell as 'row1col1', row1clo2,...etc

I have a toggle button when click on the toggle button the information should be hidden.

Can any tell me how to select the range of the grid and hide them.

Any puesdo code.

 

[Pat Hartman]

If you are asking an Excel question, you would do better in an Excel forum. If you are asking an Access question, you are committing spreadsheet but you could create a label the same color as the background, place it over the grid and toggle its .visible property to hide the controls. The only other option is a code loop that "creates" the control names since they are consistently named and toggle each of them one by one. Even easier than creating the control name is to set some value in each of the grid controls' tag property and use that to identify which controls you want to work with.