ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Borders (https://www.excelbanter.com/excel-programming/385677-borders.html)

Pasty

Borders
 
Hi There I have a macro set up now which will automatically ask questions
(plus extra ones dependant on yes/no answers.

The layout will be as below with the questions in the column D and the
answers in column A (the a,b,c questions will only be there if they answer
yes to certain questions)

1. Do you store any potentially sensitive information(e.g) customer details,
account balance information or any memorable data relating to any customers)
on a portable device? Yes
1b. If yes, what sort of information is held? Sales figures
1c. If yes, please state whether the information is held on a PDA or
laptop PDA

2. Do you have any commercial need to store information on your C-drive? Yes
If yes, please state what the commercial need is Sales Rep

3. Have you ever known of an incident in your area where a portable device
has been lost or stolen? Yes
3a. If yes, was there any information held on the C-drive at the time? Yes
3b. If yes, what information was held on the C-drive? Nude pictures of my wife
3c.If yes, could this information have been detrimental to Business
Operations or Customers if it fell into the wrong hands? Yes

There will be a cell space in between questions 1, 2 and 3 what i want it to
do is be able to detect where the end of the question is and put a border
round it is obvious to people which question is which.

Thanks



All times are GMT +1. The time now is 11:07 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com